<?php
###############   COPYLEFT GPLv3 LICENSE   ###############
##
## JFX Version 0.2.9
## Website Management Software
## www.jfxcms.com
##
## Copyright 2009 GPLv3 - http://www.opensource.org/licenses/gpl-3.0.html
##
## Anthony Gallon
## oi_antz@hotmail.com
##
## Permission is hereby granted to any person having a copy of this software
## to freely use and modify as required so long as the copyright notices
## and branding remain intact.
##
## Full license details available at http://www.jfxcms.com/license
##
###############   COPYLEFT GPLv3 LICENSE   ###############



$DB = JFX::registry('db');
if(get('country_id')=='') die('country_id is not defined');

$minPopulation = (int) $this->GetConfig('cities_min_population');

$countryId = preg_replace('/[^a-zA-Z0-9]/', '', get('country_id'));
$countryId = strtolower($countryId);
$cities = $DB->fetchAll('SELECT id, title FROM '.$CONFIG->dbprefix."iusers_cities WHERE LOWER(country_id) = '{$countryId}' AND population >= {$minPopulation} ORDER BY title ASC");

foreach($cities as $k=>$v){
    if(trim($v['title'])=='') unset($cities[$k]);
};

//die('SELECT * FROM '.$CONFIG->dbprefix."iusers_cities WHERE country_id = '{$countryId}'");

while(ob_get_level()>0) ob_end_clean();

header('Content-type: text/javascript');
die(json_encode($cities));
